<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.6"/>
<title>qLibc: extensions/qdatabase.c Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
  $(window).load(resizeHeight);
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td style="padding-left: 0.5em;">
   <div id="projectname">qLibc
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.6 -->
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>Globals</span></a></li>
    </ul>
  </div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('qdatabase_8c_source.html','');});
</script>
<div id="doc-content">
<div class="header">
  <div class="headertitle">
<div class="title">qdatabase.c</div>  </div>
</div><!--header-->
<div class="contents">
<a href="qdatabase_8c.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;<span class="comment">/******************************************************************************</span></div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="comment"> * qLibc</span></div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment"> * Copyright (c) 2010-2015 Seungyoung Kim.</span></div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="comment"> * All rights reserved.</span></div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="comment"> * Redistribution and use in source and binary forms, with or without</span></div>
<div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="comment"> * modification, are permitted provided that the following conditions are met:</span></div>
<div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="comment"> * 1. Redistributions of source code must retain the above copyright notice,</span></div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="comment"> *    this list of conditions and the following disclaimer.</span></div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="comment"> * 2. Redistributions in binary form must reproduce the above copyright notice,</span></div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="comment"> *    this list of conditions and the following disclaimer in the documentation</span></div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="comment"> *    and/or other materials provided with the distribution.</span></div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="comment"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS &quot;AS IS&quot;</span></div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="comment"> * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE</span></div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="comment"> * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE</span></div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="comment"> * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE</span></div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="comment"> * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR</span></div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="comment"> * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF</span></div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="comment"> * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS</span></div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="comment"> * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN</span></div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="comment"> * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)</span></div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="comment"> * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE</span></div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="comment"> * POSSIBILITY OF SUCH DAMAGE.</span></div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="comment"> *****************************************************************************/</span></div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;<span class="comment"> * @file qdatabase.c Database wrapper.</span></div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;<span class="comment"> * Database header files should be included prior to qlibcext.h in your source</span></div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;<span class="comment"> * codes like below.</span></div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;<span class="comment"> * @code</span></div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;<span class="comment"> *   #include &quot;mysql.h&quot;</span></div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;<span class="comment"> *   #include &quot;qlibcext.h&quot;</span></div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;<span class="comment"> * @endcode</span></div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;<span class="comment"> * @code</span></div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;<span class="comment"> *   qdb_t *db = NULL;</span></div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;<span class="comment"> *   qdbresult_t *result = NULL;</span></div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;<span class="comment"> *   db = qdb(&quot;MYSQL&quot;, &quot;dbhost.qdecoder.org&quot;, 3306,</span></div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;<span class="comment"> *            &quot;test&quot;, &quot;secret&quot;, &quot;sampledb&quot;, true);</span></div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;<span class="comment"> *   if (db == NULL) {</span></div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;<span class="comment"> *     printf(&quot;ERROR: Not supported database type.\n&quot;);</span></div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;<span class="comment"> *     return -1;</span></div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;<span class="comment"> *   }</span></div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;<span class="comment"> *   // try to connect</span></div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;<span class="comment"> *   if (db-&gt;open(db) == false) {</span></div>
<div class="line"><a name="l00053"></a><span class="lineno">   53</span>&#160;<span class="comment"> *     printf(&quot;WARNING: Can&#39;t connect to database.\n&quot;);</span></div>
<div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;<span class="comment"> *     return -1;</span></div>
<div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;<span class="comment"> *   }</span></div>
<div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;<span class="comment"> *   // get results</span></div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;<span class="comment"> *   result = db-&gt;execute_query(db, &quot;SELECT name, population FROM City&quot;);</span></div>
<div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;<span class="comment"> *   if (result != NULL) {</span></div>
<div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;<span class="comment"> *     printf(&quot;COLS : %d , ROWS : %d\n&quot;,</span></div>
<div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;<span class="comment"> *            result-&gt;get_cols(result), result-&gt;get_rows(result));</span></div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;<span class="comment"> *     while (result-&gt;get_next(result) == true) {</span></div>
<div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;<span class="comment"> *       char *pszName = result-&gt;get_str(result, &quot;name&quot;);</span></div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;<span class="comment"> *       int   nPopulation = result-&gt;get_int(result, &quot;population&quot;);</span></div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;<span class="comment"> *       printf(&quot;Country : %s , Population : %d\n&quot;, pszName, nPopulation);</span></div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;<span class="comment"> *     }</span></div>
<div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;<span class="comment"> *     result-&gt;free(result);</span></div>
<div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;<span class="comment"> *   }</span></div>
<div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;<span class="comment"> *   // close connection</span></div>
<div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;<span class="comment"> *   db-&gt;close(db);</span></div>
<div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;<span class="comment"> *   // free db object</span></div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;<span class="comment"> *   db-&gt;free(db);</span></div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;<span class="comment"> * @endcode</span></div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;</div>
<div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;<span class="preprocessor">#ifndef DISABLE_QDATABASE</span></div>
<div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;<span class="preprocessor"></span></div>
<div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160;<span class="preprocessor">#if defined(ENABLE_MYSQL) || defined( _DOXYGEN_SKIP)</span></div>
<div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160;<span class="preprocessor"></span></div>
<div class="line"><a name="l00082"></a><span class="lineno">   82</span>&#160;<span class="preprocessor">#ifdef ENABLE_MYSQL</span></div>
<div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;<span class="preprocessor"></span><span class="preprocessor">#include &quot;mysql.h&quot;</span></div>
<div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;<span class="comment">/* mysql specific connector options */</span></div>
<div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;<span class="preprocessor">#define Q_MYSQL_OPT_RECONNECT          (1)</span></div>
<div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160;<span class="preprocessor"></span><span class="preprocessor">#define Q_MYSQL_OPT_CONNECT_TIMEOUT    (10)</span></div>
<div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;<span class="preprocessor"></span><span class="preprocessor">#define Q_MYSQL_OPT_READ_TIMEOUT       (30)</span></div>
<div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;<span class="preprocessor"></span><span class="preprocessor">#define Q_MYSQL_OPT_WRITE_TIMEOUT      (30)</span></div>
<div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;<span class="preprocessor"></span><span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;<span class="preprocessor"></span></div>
<div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;<span class="preprocessor">#include &lt;stdio.h&gt;</span></div>
<div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;<span class="preprocessor">#include &lt;stdlib.h&gt;</span></div>
<div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;<span class="preprocessor">#include &lt;stdbool.h&gt;</span></div>
<div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;<span class="preprocessor">#include &lt;stdarg.h&gt;</span></div>
<div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;<span class="preprocessor">#include &lt;string.h&gt;</span></div>
<div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;<span class="preprocessor">#include &quot;qinternal.h&quot;</span></div>
<div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;<span class="preprocessor">#include &quot;extensions/qdatabase.h&quot;</span></div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;</div>
<div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;<span class="comment">/*</span></div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;<span class="comment"> * Member method protos</span></div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;<span class="preprocessor">#ifndef _DOXYGEN_SKIP</span></div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;<span class="preprocessor"></span><span class="comment">// qdb_t object</span></div>
<div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#ae90a2206952d27df4a58995628741134">open_</a>(qdb_t *db);</div>
<div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>(qdb_t *db);</div>
<div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;</div>
<div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a42069ce53c9e45b7283e9e44a7e021d9">execute_update</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *query);</div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a99e372b7dd8e2d9c2bb4f762cc8dd5aa">execute_updatef</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *format, ...);</div>
<div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;<span class="keyword">static</span> qdbresult_t *<a class="code" href="qdatabase_8c.html#abe4e5330b68b3fc9ff94b086939dba82">execute_query</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *query);</div>
<div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;<span class="keyword">static</span> qdbresult_t *<a class="code" href="qdatabase_8c.html#a6fde99c74f91137ac554244ac60344be">execute_queryf</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *format, ...);</div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;</div>
<div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a2f27adbcda036187a4714e5bcd3a247e">begin_tran</a>(qdb_t *db);</div>
<div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a3386b5894d03e2f48deecb0b7c0632ea">commit</a>(qdb_t *db);</div>
<div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a6ee4a69fbc4ecf80e795d6b6b3750ca7">rollback</a>(qdb_t *db);</div>
<div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;</div>
<div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a5dc988c35746fe8a792702523abc66b3">set_fetchtype</a>(qdb_t *db, <span class="keywordtype">bool</span> use);</div>
<div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a0598e067ed6b749c9df042cd7bc83f5c">get_conn_status</a>(qdb_t *db);</div>
<div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a998f1143e4b00ff847f120e34a0efc0d">ping</a>(qdb_t *db);</div>
<div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;<span class="keyword">static</span> <span class="keyword">const</span> <span class="keywordtype">char</span> *<a class="code" href="qdatabase_8c.html#a11f5b1c5de493c27e1d396f7593408a0">get_error</a>(qdb_t *db, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> *errorno);</div>
<div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;<span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="qdatabase_8c.html#afe5578f18ea12e68e96a80b91bd9be9d">free_</a>(qdb_t *db);</div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;</div>
<div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;<span class="comment">// qdbresult_t object</span></div>
<div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;<span class="keyword">static</span> <span class="keyword">const</span> <span class="keywordtype">char</span> *<a class="code" href="qdatabase_8c.html#a3c32ab62afb92fb6a55cfaff7c92bf42">_resultGetStr</a>(qdbresult_t *result, <span class="keyword">const</span> <span class="keywordtype">char</span> *field);</div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;<span class="keyword">static</span> <span class="keyword">const</span> <span class="keywordtype">char</span> *<a class="code" href="qdatabase_8c.html#ae3559441aaa0ae5f19965612dccca8d5">_resultGetStrAt</a>(qdbresult_t *result, <span class="keywordtype">int</span> idx);</div>
<div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#aa7608c9e6913b4d3c71d62cd43073fd1">_resultGetInt</a>(qdbresult_t *result, <span class="keyword">const</span> <span class="keywordtype">char</span> *field);</div>
<div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a6b5beda54ba78647276bc180f65138ca">_resultGetIntAt</a>(qdbresult_t *result, <span class="keywordtype">int</span> idx);</div>
<div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#aeb86d8858bb8ea5dd06e052f8f3e9a09">_resultGetNext</a>(qdbresult_t *result);</div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;</div>
<div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a95d88451db51492ae6122701ce56b94d">result_get_cols</a>(qdbresult_t *result);</div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a26f8b55348c57f467d64c002ab306ff6">result_get_rows</a>(qdbresult_t *result);</div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a396a7328f7fb499f89c2652598185dc8">result_get_row</a>(qdbresult_t *result);</div>
<div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;</div>
<div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;<span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="qdatabase_8c.html#a4ab66a07fa82b706895e1b2c19fcd501">result_free</a>(qdbresult_t *result);</div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;</div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;<span class="preprocessor"></span><span class="comment"></span></div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;<span class="comment"> * Initialize internal connector structure</span></div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;<span class="comment"> * @param dbtype    database server type. currently &quot;MYSQL&quot; is only supported</span></div>
<div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;<span class="comment"> * @param addr      ip or fqdn address.</span></div>
<div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;<span class="comment"> * @param port      port number</span></div>
<div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;<span class="comment"> * @param username  database username</span></div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;<span class="comment"> * @param password  database password</span></div>
<div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;<span class="comment"> * @param database  database server type. currently &quot;MYSQL&quot; is only supported</span></div>
<div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;<span class="comment"> * @param autocommit sets autocommit mode on if autocommit is true, off if</span></div>
<div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;<span class="comment"> *                   autocommit is false</span></div>
<div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;<span class="comment"> * @return a pointer of qdb_t object in case of successful,</span></div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;<span class="comment"> *         otherwise returns NULL.</span></div>
<div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;<span class="comment"> * @code</span></div>
<div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;<span class="comment"> *   qdb_t *db = qdb(&quot;MYSQL&quot;,</span></div>
<div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;<span class="comment"> *                   &quot;dbhost.qdecoder.org&quot;, 3306, &quot;test&quot;, &quot;secret&quot;,</span></div>
<div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;<span class="comment"> *                   &quot;sampledb&quot;, true);</span></div>
<div class="line"><a name="l00156"></a><span class="lineno">  156</span>&#160;<span class="comment"> *   if (db == NULL) {</span></div>
<div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;<span class="comment"> *     printf(&quot;ERROR: Not supported database type.\n&quot;);</span></div>
<div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;<span class="comment"> *     return -1;</span></div>
<div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;<span class="comment"> *   }</span></div>
<div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;<span class="comment"> * @endcode</span></div>
<div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00162"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a5feeb5a7ad2b8531d2bdc2d5e94e344f">  162</a></span>&#160;qdb_t *<a class="code" href="qdatabase_8c.html#a5feeb5a7ad2b8531d2bdc2d5e94e344f">qdb</a>(<span class="keyword">const</span> <span class="keywordtype">char</span> *dbtype, <span class="keyword">const</span> <span class="keywordtype">char</span> *addr, <span class="keywordtype">int</span> port, <span class="keyword">const</span> <span class="keywordtype">char</span> *username,</div>
<div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;        <span class="keyword">const</span> <span class="keywordtype">char</span> *password, <span class="keyword">const</span> <span class="keywordtype">char</span> *database, <span class="keywordtype">bool</span> autocommit)</div>
<div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;{</div>
<div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;    <span class="comment">// check db type</span></div>
<div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (strcmp(dbtype, <span class="stringliteral">&quot;MYSQL&quot;</span>)) <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (dbtype == NULL</div>
<div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;            || addr == NULL</div>
<div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;            || username == NULL</div>
<div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;            || password == NULL</div>
<div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;            || database == NULL) {</div>
<div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;        <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;    }</div>
<div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;</div>
<div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;    <span class="comment">// initialize</span></div>
<div class="line"><a name="l00180"></a><span class="lineno">  180</span>&#160;    qdb_t *db;</div>
<div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;    <span class="keywordflow">if</span> ((db = (qdb_t *)malloc(<span class="keyword">sizeof</span>(qdb_t))) == NULL) <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160;    memset((<span class="keywordtype">void</span> *)db, 0, <span class="keyword">sizeof</span>(qdb_t));</div>
<div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;    db-&gt;connected = <span class="keyword">false</span>;</div>
<div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;</div>
<div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;    <span class="comment">// set common structure</span></div>
<div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;    db-&gt;info.dbtype = strdup(dbtype);</div>
<div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;    db-&gt;info.addr = strdup(addr);</div>
<div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;    db-&gt;info.port = port;</div>
<div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;    db-&gt;info.username = strdup(username);</div>
<div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;    db-&gt;info.password = strdup(password);</div>
<div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160;    db-&gt;info.database = strdup(database);</div>
<div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;    db-&gt;info.autocommit = autocommit;</div>
<div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;    db-&gt;info.fetchtype = <span class="keyword">false</span>;<span class="comment">// store mode</span></div>
<div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160;</div>
<div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;    <span class="comment">// set db handler</span></div>
<div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;<span class="preprocessor"></span>    db-&gt;mysql = NULL;</div>
<div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;<span class="preprocessor"></span></div>
<div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;    <span class="comment">// assign methods</span></div>
<div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;    db-&gt;open = <a class="code" href="qdatabase_8c.html#ae90a2206952d27df4a58995628741134">open_</a>;</div>
<div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160;    db-&gt;close = <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>;</div>
<div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160;</div>
<div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;    db-&gt;execute_update = <a class="code" href="qdatabase_8c.html#a42069ce53c9e45b7283e9e44a7e021d9">execute_update</a>;</div>
<div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;    db-&gt;execute_updatef = <a class="code" href="qdatabase_8c.html#a99e372b7dd8e2d9c2bb4f762cc8dd5aa">execute_updatef</a>;</div>
<div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;    db-&gt;execute_query = <a class="code" href="qdatabase_8c.html#abe4e5330b68b3fc9ff94b086939dba82">execute_query</a>;</div>
<div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;    db-&gt;execute_queryf = <a class="code" href="qdatabase_8c.html#a6fde99c74f91137ac554244ac60344be">execute_queryf</a>;</div>
<div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;</div>
<div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;    db-&gt;begin_tran = <a class="code" href="qdatabase_8c.html#a2f27adbcda036187a4714e5bcd3a247e">begin_tran</a>;</div>
<div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;    db-&gt;commit = <a class="code" href="qdatabase_8c.html#a3386b5894d03e2f48deecb0b7c0632ea">commit</a>;</div>
<div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;    db-&gt;rollback = <a class="code" href="qdatabase_8c.html#a6ee4a69fbc4ecf80e795d6b6b3750ca7">rollback</a>;</div>
<div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160;</div>
<div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;    db-&gt;set_fetchtype = <a class="code" href="qdatabase_8c.html#a5dc988c35746fe8a792702523abc66b3">set_fetchtype</a>;</div>
<div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;    db-&gt;get_conn_status = <a class="code" href="qdatabase_8c.html#a0598e067ed6b749c9df042cd7bc83f5c">get_conn_status</a>;</div>
<div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;    db-&gt;ping = <a class="code" href="qdatabase_8c.html#a998f1143e4b00ff847f120e34a0efc0d">ping</a>;</div>
<div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;    db-&gt;get_error = <a class="code" href="qdatabase_8c.html#a11f5b1c5de493c27e1d396f7593408a0">get_error</a>;</div>
<div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;    db-&gt;free = <a class="code" href="qdatabase_8c.html#afe5578f18ea12e68e96a80b91bd9be9d">free_</a>;</div>
<div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;</div>
<div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;    <span class="comment">// initialize recrusive mutex</span></div>
<div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;    Q_MUTEX_NEW(db-&gt;qmutex, <span class="keyword">true</span>);</div>
<div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;</div>
<div class="line"><a name="l00222"></a><span class="lineno">  222</span>&#160;    <span class="keywordflow">return</span> db;</div>
<div class="line"><a name="l00223"></a><span class="lineno">  223</span>&#160;}</div>
<div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160;<span class="comment"> * qdb-&gt;open(): Connect to database server</span></div>
<div class="line"><a name="l00227"></a><span class="lineno">  227</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00230"></a><span class="lineno">  230</span>&#160;<span class="comment"> * @return true if successful, otherwise returns false.</span></div>
<div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00232"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#ae90a2206952d27df4a58995628741134">  232</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#ae90a2206952d27df4a58995628741134">open_</a>(qdb_t *db)</div>
<div class="line"><a name="l00233"></a><span class="lineno">  233</span>&#160;{</div>
<div class="line"><a name="l00234"></a><span class="lineno">  234</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00235"></a><span class="lineno">  235</span>&#160;</div>
<div class="line"><a name="l00236"></a><span class="lineno">  236</span>&#160;    <span class="comment">// if connected, close first</span></div>
<div class="line"><a name="l00237"></a><span class="lineno">  237</span>&#160;    <span class="keywordflow">if</span> (db-&gt;connected == <span class="keyword">true</span>) {</div>
<div class="line"><a name="l00238"></a><span class="lineno">  238</span>&#160;        <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>(db);</div>
<div class="line"><a name="l00239"></a><span class="lineno">  239</span>&#160;    }</div>
<div class="line"><a name="l00240"></a><span class="lineno">  240</span>&#160;</div>
<div class="line"><a name="l00241"></a><span class="lineno">  241</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160;<span class="preprocessor"></span>    Q_MUTEX_ENTER(db-&gt;qmutex);</div>
<div class="line"><a name="l00243"></a><span class="lineno">  243</span>&#160;</div>
<div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;    <span class="comment">// initialize handler</span></div>
<div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;    <span class="keywordflow">if</span> (db-&gt;mysql != NULL) <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>(db);</div>
<div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;</div>
<div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160;    <span class="keywordflow">if</span> (mysql_library_init(0, NULL, NULL) != 0) {</div>
<div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00249"></a><span class="lineno">  249</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00250"></a><span class="lineno">  250</span>&#160;    }</div>
<div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;</div>
<div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160;    <span class="keywordflow">if</span> ((db-&gt;mysql = mysql_init(NULL)) == NULL) {</div>
<div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;    }</div>
<div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;</div>
<div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;    <span class="comment">// set options</span></div>
<div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;    my_bool reconnect = Q_MYSQL_OPT_RECONNECT;</div>
<div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;    <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> connect_timeout = Q_MYSQL_OPT_CONNECT_TIMEOUT;</div>
<div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;    <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> read_timeout = Q_MYSQL_OPT_READ_TIMEOUT;</div>
<div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;    <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> write_timeout = Q_MYSQL_OPT_WRITE_TIMEOUT;</div>
<div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;</div>
<div class="line"><a name="l00263"></a><span class="lineno">  263</span>&#160;    <span class="keywordflow">if</span> (reconnect != <span class="keyword">false</span>) {</div>
<div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;        mysql_options(db-&gt;mysql,</div>
<div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;                MYSQL_OPT_RECONNECT,</div>
<div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;                (<span class="keywordtype">char</span> *)&amp;reconnect);</div>
<div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;    }</div>
<div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;    <span class="keywordflow">if</span> (connect_timeout &gt; 0) {</div>
<div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160;        mysql_options(db-&gt;mysql,</div>
<div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;                MYSQL_OPT_CONNECT_TIMEOUT,</div>
<div class="line"><a name="l00271"></a><span class="lineno">  271</span>&#160;                (<span class="keywordtype">char</span> *)&amp;connect_timeout);</div>
<div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;    }</div>
<div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;    <span class="keywordflow">if</span> (read_timeout &gt; 0) {</div>
<div class="line"><a name="l00274"></a><span class="lineno">  274</span>&#160;        mysql_options(db-&gt;mysql,</div>
<div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160;                MYSQL_OPT_READ_TIMEOUT,</div>
<div class="line"><a name="l00276"></a><span class="lineno">  276</span>&#160;                (<span class="keywordtype">char</span> *)&amp;read_timeout);</div>
<div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;    }</div>
<div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;    <span class="keywordflow">if</span> (write_timeout &gt; 0) {</div>
<div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;        mysql_options(db-&gt;mysql,</div>
<div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;                MYSQL_OPT_WRITE_TIMEOUT,</div>
<div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160;                (<span class="keywordtype">char</span> *)&amp;write_timeout);</div>
<div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160;    }</div>
<div class="line"><a name="l00283"></a><span class="lineno">  283</span>&#160;</div>
<div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;    <span class="comment">// try to connect</span></div>
<div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;    <span class="keywordflow">if</span> (mysql_real_connect(db-&gt;mysql,</div>
<div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;                    db-&gt;info.addr,</div>
<div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;                    db-&gt;info.username,</div>
<div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;                    db-&gt;info.password,</div>
<div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;                    db-&gt;info.database,</div>
<div class="line"><a name="l00290"></a><span class="lineno">  290</span>&#160;                    db-&gt;info.port, NULL, 0) == NULL) {</div>
<div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;        <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>(db);  <span class="comment">// free mysql handler</span></div>
<div class="line"><a name="l00292"></a><span class="lineno">  292</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160;    }</div>
<div class="line"><a name="l00295"></a><span class="lineno">  295</span>&#160;</div>
<div class="line"><a name="l00296"></a><span class="lineno">  296</span>&#160;    <span class="comment">// set auto-commit</span></div>
<div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;    <span class="keywordflow">if</span> (mysql_autocommit(db-&gt;mysql, db-&gt;info.autocommit) != 0) {</div>
<div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;        <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>(db);  <span class="comment">// free mysql handler</span></div>
<div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00300"></a><span class="lineno">  300</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;    }</div>
<div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;</div>
<div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;    <span class="comment">// set flag</span></div>
<div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160;    db-&gt;connected = <span class="keyword">true</span>;</div>
<div class="line"><a name="l00305"></a><span class="lineno">  305</span>&#160;    Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00306"></a><span class="lineno">  306</span>&#160;    <span class="keywordflow">return</span> <span class="keyword">true</span>;</div>
<div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00310"></a><span class="lineno">  310</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00311"></a><span class="lineno">  311</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;<span class="comment"> * qdb-&gt;close(): Disconnect from database server</span></div>
<div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00315"></a><span class="lineno">  315</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;<span class="comment"> * @return true if successful, otherwise returns false.</span></div>
<div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;<span class="comment"> * @note</span></div>
<div class="line"><a name="l00320"></a><span class="lineno">  320</span>&#160;<span class="comment"> *  Unless you call qdb-&gt;free(), qdb_t object will keep the database</span></div>
<div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;<span class="comment"> *  information. So you can re-connect to database using qdb-&gt;open().</span></div>
<div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00323"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">  323</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>(qdb_t *db)</div>
<div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160;{</div>
<div class="line"><a name="l00325"></a><span class="lineno">  325</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160;</div>
<div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;<span class="preprocessor"></span>    Q_MUTEX_ENTER(db-&gt;qmutex);</div>
<div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;</div>
<div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;    <span class="keywordflow">if</span> (db-&gt;mysql != NULL) {</div>
<div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160;        mysql_close(db-&gt;mysql);</div>
<div class="line"><a name="l00332"></a><span class="lineno">  332</span>&#160;        db-&gt;mysql = NULL;</div>
<div class="line"><a name="l00333"></a><span class="lineno">  333</span>&#160;        mysql_library_end();</div>
<div class="line"><a name="l00334"></a><span class="lineno">  334</span>&#160;    }</div>
<div class="line"><a name="l00335"></a><span class="lineno">  335</span>&#160;    db-&gt;connected = <span class="keyword">false</span>;</div>
<div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;</div>
<div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160;    Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00338"></a><span class="lineno">  338</span>&#160;    <span class="keywordflow">return</span> <span class="keyword">true</span>;</div>
<div class="line"><a name="l00339"></a><span class="lineno">  339</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00340"></a><span class="lineno">  340</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00341"></a><span class="lineno">  341</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00342"></a><span class="lineno">  342</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00343"></a><span class="lineno">  343</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00344"></a><span class="lineno">  344</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00345"></a><span class="lineno">  345</span>&#160;<span class="comment"> * qdb-&gt;execute_update(): Executes the update DML</span></div>
<div class="line"><a name="l00346"></a><span class="lineno">  346</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00347"></a><span class="lineno">  347</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00348"></a><span class="lineno">  348</span>&#160;<span class="comment"> * @param query     query string</span></div>
<div class="line"><a name="l00349"></a><span class="lineno">  349</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00350"></a><span class="lineno">  350</span>&#160;<span class="comment"> * @return a number of affected rows</span></div>
<div class="line"><a name="l00351"></a><span class="lineno">  351</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00352"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a42069ce53c9e45b7283e9e44a7e021d9">  352</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a42069ce53c9e45b7283e9e44a7e021d9">execute_update</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *query)</div>
<div class="line"><a name="l00353"></a><span class="lineno">  353</span>&#160;{</div>
<div class="line"><a name="l00354"></a><span class="lineno">  354</span>&#160;    <span class="keywordflow">if</span> (db == NULL || db-&gt;connected == <span class="keyword">false</span>) <span class="keywordflow">return</span> -1;</div>
<div class="line"><a name="l00355"></a><span class="lineno">  355</span>&#160;</div>
<div class="line"><a name="l00356"></a><span class="lineno">  356</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00357"></a><span class="lineno">  357</span>&#160;<span class="preprocessor"></span>    Q_MUTEX_ENTER(db-&gt;qmutex);</div>
<div class="line"><a name="l00358"></a><span class="lineno">  358</span>&#160;</div>
<div class="line"><a name="l00359"></a><span class="lineno">  359</span>&#160;    <span class="keywordtype">int</span> affected = -1;</div>
<div class="line"><a name="l00360"></a><span class="lineno">  360</span>&#160;</div>
<div class="line"><a name="l00361"></a><span class="lineno">  361</span>&#160;    <span class="comment">// query</span></div>
<div class="line"><a name="l00362"></a><span class="lineno">  362</span>&#160;    DEBUG(<span class="stringliteral">&quot;%s&quot;</span>, query);</div>
<div class="line"><a name="l00363"></a><span class="lineno">  363</span>&#160;    <span class="keywordflow">if</span> (mysql_query(db-&gt;mysql, query) == 0) {</div>
<div class="line"><a name="l00364"></a><span class="lineno">  364</span>&#160;        <span class="comment">/* get affected rows */</span></div>
<div class="line"><a name="l00365"></a><span class="lineno">  365</span>&#160;        <span class="keywordflow">if</span> ((affected = mysql_affected_rows(db-&gt;mysql)) &lt; 0) affected = -1;</div>
<div class="line"><a name="l00366"></a><span class="lineno">  366</span>&#160;    }</div>
<div class="line"><a name="l00367"></a><span class="lineno">  367</span>&#160;</div>
<div class="line"><a name="l00368"></a><span class="lineno">  368</span>&#160;    Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00369"></a><span class="lineno">  369</span>&#160;    <span class="keywordflow">return</span> affected;</div>
<div class="line"><a name="l00370"></a><span class="lineno">  370</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00371"></a><span class="lineno">  371</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> -1;</div>
<div class="line"><a name="l00372"></a><span class="lineno">  372</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00373"></a><span class="lineno">  373</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00374"></a><span class="lineno">  374</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00375"></a><span class="lineno">  375</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00376"></a><span class="lineno">  376</span>&#160;<span class="comment"> * qdb-&gt;execute_updatef(): Executes the formatted update DML</span></div>
<div class="line"><a name="l00377"></a><span class="lineno">  377</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00378"></a><span class="lineno">  378</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00379"></a><span class="lineno">  379</span>&#160;<span class="comment"> * @param format    query string format</span></div>
<div class="line"><a name="l00380"></a><span class="lineno">  380</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00381"></a><span class="lineno">  381</span>&#160;<span class="comment"> * @return a number of affected rows, otherwise returns -1</span></div>
<div class="line"><a name="l00382"></a><span class="lineno">  382</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00383"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a99e372b7dd8e2d9c2bb4f762cc8dd5aa">  383</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a99e372b7dd8e2d9c2bb4f762cc8dd5aa">execute_updatef</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *format, ...)</div>
<div class="line"><a name="l00384"></a><span class="lineno">  384</span>&#160;{</div>
<div class="line"><a name="l00385"></a><span class="lineno">  385</span>&#160;    <span class="keywordtype">char</span> *query;</div>
<div class="line"><a name="l00386"></a><span class="lineno">  386</span>&#160;    DYNAMIC_VSPRINTF(query, format);</div>
<div class="line"><a name="l00387"></a><span class="lineno">  387</span>&#160;    <span class="keywordflow">if</span> (query == NULL) <span class="keywordflow">return</span> -1;</div>
<div class="line"><a name="l00388"></a><span class="lineno">  388</span>&#160;</div>
<div class="line"><a name="l00389"></a><span class="lineno">  389</span>&#160;    <span class="keywordtype">int</span> affected = <a class="code" href="qdatabase_8c.html#a42069ce53c9e45b7283e9e44a7e021d9">execute_update</a>(db, query);</div>
<div class="line"><a name="l00390"></a><span class="lineno">  390</span>&#160;    free(query);</div>
<div class="line"><a name="l00391"></a><span class="lineno">  391</span>&#160;</div>
<div class="line"><a name="l00392"></a><span class="lineno">  392</span>&#160;    <span class="keywordflow">return</span> affected;</div>
<div class="line"><a name="l00393"></a><span class="lineno">  393</span>&#160;}</div>
<div class="line"><a name="l00394"></a><span class="lineno">  394</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00395"></a><span class="lineno">  395</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00396"></a><span class="lineno">  396</span>&#160;<span class="comment"> * qdb-&gt;execute_query(): Executes the query</span></div>
<div class="line"><a name="l00397"></a><span class="lineno">  397</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00398"></a><span class="lineno">  398</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00399"></a><span class="lineno">  399</span>&#160;<span class="comment"> * @param query     query string</span></div>
<div class="line"><a name="l00400"></a><span class="lineno">  400</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00401"></a><span class="lineno">  401</span>&#160;<span class="comment"> * @return a pointer of qdbresult_t if successful, otherwise returns NULL</span></div>
<div class="line"><a name="l00402"></a><span class="lineno">  402</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00403"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#abe4e5330b68b3fc9ff94b086939dba82">  403</a></span>&#160;<span class="keyword">static</span> qdbresult_t *<a class="code" href="qdatabase_8c.html#abe4e5330b68b3fc9ff94b086939dba82">execute_query</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *query)</div>
<div class="line"><a name="l00404"></a><span class="lineno">  404</span>&#160;{</div>
<div class="line"><a name="l00405"></a><span class="lineno">  405</span>&#160;    <span class="keywordflow">if</span> (db == NULL || db-&gt;connected == <span class="keyword">false</span>) <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00406"></a><span class="lineno">  406</span>&#160;</div>
<div class="line"><a name="l00407"></a><span class="lineno">  407</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00408"></a><span class="lineno">  408</span>&#160;<span class="preprocessor"></span>    <span class="comment">// query</span></div>
<div class="line"><a name="l00409"></a><span class="lineno">  409</span>&#160;    DEBUG(<span class="stringliteral">&quot;%s&quot;</span>, query);</div>
<div class="line"><a name="l00410"></a><span class="lineno">  410</span>&#160;    <span class="keywordflow">if</span> (mysql_query(db-&gt;mysql, query)) <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00411"></a><span class="lineno">  411</span>&#160;</div>
<div class="line"><a name="l00412"></a><span class="lineno">  412</span>&#160;    <span class="comment">// store</span></div>
<div class="line"><a name="l00413"></a><span class="lineno">  413</span>&#160;    qdbresult_t *result = (qdbresult_t *)malloc(<span class="keyword">sizeof</span>(qdbresult_t));</div>
<div class="line"><a name="l00414"></a><span class="lineno">  414</span>&#160;    <span class="keywordflow">if</span> (result == NULL) <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00415"></a><span class="lineno">  415</span>&#160;</div>
<div class="line"><a name="l00416"></a><span class="lineno">  416</span>&#160;    result-&gt;fetchtype = db-&gt;info.fetchtype;</div>
<div class="line"><a name="l00417"></a><span class="lineno">  417</span>&#160;    <span class="keywordflow">if</span> (result-&gt;fetchtype == <span class="keyword">false</span>) {</div>
<div class="line"><a name="l00418"></a><span class="lineno">  418</span>&#160;        result-&gt;rs = mysql_store_result(db-&gt;mysql);</div>
<div class="line"><a name="l00419"></a><span class="lineno">  419</span>&#160;    } <span class="keywordflow">else</span> {</div>
<div class="line"><a name="l00420"></a><span class="lineno">  420</span>&#160;        result-&gt;rs = mysql_use_result(db-&gt;mysql);</div>
<div class="line"><a name="l00421"></a><span class="lineno">  421</span>&#160;    }</div>
<div class="line"><a name="l00422"></a><span class="lineno">  422</span>&#160;    <span class="keywordflow">if</span> (result-&gt;rs == NULL) {</div>
<div class="line"><a name="l00423"></a><span class="lineno">  423</span>&#160;        free(result);</div>
<div class="line"><a name="l00424"></a><span class="lineno">  424</span>&#160;        <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00425"></a><span class="lineno">  425</span>&#160;    }</div>
<div class="line"><a name="l00426"></a><span class="lineno">  426</span>&#160;</div>
<div class="line"><a name="l00427"></a><span class="lineno">  427</span>&#160;    <span class="comment">/* get meta data */</span></div>
<div class="line"><a name="l00428"></a><span class="lineno">  428</span>&#160;    result-&gt;fields = NULL;</div>
<div class="line"><a name="l00429"></a><span class="lineno">  429</span>&#160;    result-&gt;row = NULL;</div>
<div class="line"><a name="l00430"></a><span class="lineno">  430</span>&#160;    result-&gt;cols = mysql_num_fields(result-&gt;rs);</div>
<div class="line"><a name="l00431"></a><span class="lineno">  431</span>&#160;    result-&gt;cursor = 0;</div>
<div class="line"><a name="l00432"></a><span class="lineno">  432</span>&#160;</div>
<div class="line"><a name="l00433"></a><span class="lineno">  433</span>&#160;    <span class="comment">/* assign methods */</span></div>
<div class="line"><a name="l00434"></a><span class="lineno">  434</span>&#160;    result-&gt;get_str = <a class="code" href="qdatabase_8c.html#a3c32ab62afb92fb6a55cfaff7c92bf42">_resultGetStr</a>;</div>
<div class="line"><a name="l00435"></a><span class="lineno">  435</span>&#160;    result-&gt;get_str_at = <a class="code" href="qdatabase_8c.html#ae3559441aaa0ae5f19965612dccca8d5">_resultGetStrAt</a>;</div>
<div class="line"><a name="l00436"></a><span class="lineno">  436</span>&#160;    result-&gt;get_int = <a class="code" href="qdatabase_8c.html#aa7608c9e6913b4d3c71d62cd43073fd1">_resultGetInt</a>;</div>
<div class="line"><a name="l00437"></a><span class="lineno">  437</span>&#160;    result-&gt;get_int_at = <a class="code" href="qdatabase_8c.html#a6b5beda54ba78647276bc180f65138ca">_resultGetIntAt</a>;</div>
<div class="line"><a name="l00438"></a><span class="lineno">  438</span>&#160;    result-&gt;get_next = <a class="code" href="qdatabase_8c.html#aeb86d8858bb8ea5dd06e052f8f3e9a09">_resultGetNext</a>;</div>
<div class="line"><a name="l00439"></a><span class="lineno">  439</span>&#160;</div>
<div class="line"><a name="l00440"></a><span class="lineno">  440</span>&#160;    result-&gt;get_cols = <a class="code" href="qdatabase_8c.html#a95d88451db51492ae6122701ce56b94d">result_get_cols</a>;</div>
<div class="line"><a name="l00441"></a><span class="lineno">  441</span>&#160;    result-&gt;get_rows = <a class="code" href="qdatabase_8c.html#a26f8b55348c57f467d64c002ab306ff6">result_get_rows</a>;</div>
<div class="line"><a name="l00442"></a><span class="lineno">  442</span>&#160;    result-&gt;get_row = <a class="code" href="qdatabase_8c.html#a396a7328f7fb499f89c2652598185dc8">result_get_row</a>;</div>
<div class="line"><a name="l00443"></a><span class="lineno">  443</span>&#160;</div>
<div class="line"><a name="l00444"></a><span class="lineno">  444</span>&#160;    result-&gt;free = <a class="code" href="qdatabase_8c.html#a4ab66a07fa82b706895e1b2c19fcd501">result_free</a>;</div>
<div class="line"><a name="l00445"></a><span class="lineno">  445</span>&#160;</div>
<div class="line"><a name="l00446"></a><span class="lineno">  446</span>&#160;    <span class="keywordflow">return</span> result;</div>
<div class="line"><a name="l00447"></a><span class="lineno">  447</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00448"></a><span class="lineno">  448</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00449"></a><span class="lineno">  449</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00450"></a><span class="lineno">  450</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00451"></a><span class="lineno">  451</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00452"></a><span class="lineno">  452</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00453"></a><span class="lineno">  453</span>&#160;<span class="comment"> * qdb-&gt;execute_queryf(): Executes the formatted query</span></div>
<div class="line"><a name="l00454"></a><span class="lineno">  454</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00455"></a><span class="lineno">  455</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00456"></a><span class="lineno">  456</span>&#160;<span class="comment"> * @param format    query string format</span></div>
<div class="line"><a name="l00457"></a><span class="lineno">  457</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00458"></a><span class="lineno">  458</span>&#160;<span class="comment"> * @return a pointer of qdbresult_t if successful, otherwise returns NULL</span></div>
<div class="line"><a name="l00459"></a><span class="lineno">  459</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00460"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a6fde99c74f91137ac554244ac60344be">  460</a></span>&#160;<span class="keyword">static</span> qdbresult_t *<a class="code" href="qdatabase_8c.html#a6fde99c74f91137ac554244ac60344be">execute_queryf</a>(qdb_t *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *format, ...)</div>
<div class="line"><a name="l00461"></a><span class="lineno">  461</span>&#160;{</div>
<div class="line"><a name="l00462"></a><span class="lineno">  462</span>&#160;    <span class="keywordtype">char</span> *query;</div>
<div class="line"><a name="l00463"></a><span class="lineno">  463</span>&#160;    DYNAMIC_VSPRINTF(query, format);</div>
<div class="line"><a name="l00464"></a><span class="lineno">  464</span>&#160;    <span class="keywordflow">if</span> (query == NULL) <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00465"></a><span class="lineno">  465</span>&#160;</div>
<div class="line"><a name="l00466"></a><span class="lineno">  466</span>&#160;    qdbresult_t *ret = db-&gt;execute_query(db, query);</div>
<div class="line"><a name="l00467"></a><span class="lineno">  467</span>&#160;    free(query);</div>
<div class="line"><a name="l00468"></a><span class="lineno">  468</span>&#160;    <span class="keywordflow">return</span> ret;</div>
<div class="line"><a name="l00469"></a><span class="lineno">  469</span>&#160;}</div>
<div class="line"><a name="l00470"></a><span class="lineno">  470</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00471"></a><span class="lineno">  471</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00472"></a><span class="lineno">  472</span>&#160;<span class="comment"> * qdb-&gt;begin_tran(): Start transaction</span></div>
<div class="line"><a name="l00473"></a><span class="lineno">  473</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00474"></a><span class="lineno">  474</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00475"></a><span class="lineno">  475</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00476"></a><span class="lineno">  476</span>&#160;<span class="comment"> * @return true if successful, otherwise returns false</span></div>
<div class="line"><a name="l00477"></a><span class="lineno">  477</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00478"></a><span class="lineno">  478</span>&#160;<span class="comment"> * @code</span></div>
<div class="line"><a name="l00479"></a><span class="lineno">  479</span>&#160;<span class="comment"> *   db-&gt;begin_tran(db);</span></div>
<div class="line"><a name="l00480"></a><span class="lineno">  480</span>&#160;<span class="comment"> *   (... insert/update/delete ...)</span></div>
<div class="line"><a name="l00481"></a><span class="lineno">  481</span>&#160;<span class="comment"> *   db-&gt;commit(db);</span></div>
<div class="line"><a name="l00482"></a><span class="lineno">  482</span>&#160;<span class="comment"> * @endcode</span></div>
<div class="line"><a name="l00483"></a><span class="lineno">  483</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00484"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a2f27adbcda036187a4714e5bcd3a247e">  484</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a2f27adbcda036187a4714e5bcd3a247e">begin_tran</a>(qdb_t *db)</div>
<div class="line"><a name="l00485"></a><span class="lineno">  485</span>&#160;{</div>
<div class="line"><a name="l00486"></a><span class="lineno">  486</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00487"></a><span class="lineno">  487</span>&#160;</div>
<div class="line"><a name="l00488"></a><span class="lineno">  488</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00489"></a><span class="lineno">  489</span>&#160;<span class="preprocessor"></span>    Q_MUTEX_ENTER(db-&gt;qmutex);</div>
<div class="line"><a name="l00490"></a><span class="lineno">  490</span>&#160;    <span class="keywordflow">if</span> (db-&gt;qmutex.count != 1) {</div>
<div class="line"><a name="l00491"></a><span class="lineno">  491</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00492"></a><span class="lineno">  492</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00493"></a><span class="lineno">  493</span>&#160;    }</div>
<div class="line"><a name="l00494"></a><span class="lineno">  494</span>&#160;</div>
<div class="line"><a name="l00495"></a><span class="lineno">  495</span>&#160;    qdbresult_t *result;</div>
<div class="line"><a name="l00496"></a><span class="lineno">  496</span>&#160;    result = db-&gt;execute_query(db, <span class="stringliteral">&quot;START TRANSACTION&quot;</span>);</div>
<div class="line"><a name="l00497"></a><span class="lineno">  497</span>&#160;    <span class="keywordflow">if</span> (result == NULL) {</div>
<div class="line"><a name="l00498"></a><span class="lineno">  498</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00499"></a><span class="lineno">  499</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00500"></a><span class="lineno">  500</span>&#160;    }</div>
<div class="line"><a name="l00501"></a><span class="lineno">  501</span>&#160;    result-&gt;free(result);</div>
<div class="line"><a name="l00502"></a><span class="lineno">  502</span>&#160;    <span class="keywordflow">return</span> <span class="keyword">true</span>;</div>
<div class="line"><a name="l00503"></a><span class="lineno">  503</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00504"></a><span class="lineno">  504</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00505"></a><span class="lineno">  505</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00506"></a><span class="lineno">  506</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00507"></a><span class="lineno">  507</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00508"></a><span class="lineno">  508</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00509"></a><span class="lineno">  509</span>&#160;<span class="comment"> * qdb-&gt;commit(): Commit transaction</span></div>
<div class="line"><a name="l00510"></a><span class="lineno">  510</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00511"></a><span class="lineno">  511</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00512"></a><span class="lineno">  512</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00513"></a><span class="lineno">  513</span>&#160;<span class="comment"> * @return true if successful, otherwise returns false</span></div>
<div class="line"><a name="l00514"></a><span class="lineno">  514</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00515"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a3386b5894d03e2f48deecb0b7c0632ea">  515</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a3386b5894d03e2f48deecb0b7c0632ea">commit</a>(qdb_t *db)</div>
<div class="line"><a name="l00516"></a><span class="lineno">  516</span>&#160;{</div>
<div class="line"><a name="l00517"></a><span class="lineno">  517</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00518"></a><span class="lineno">  518</span>&#160;</div>
<div class="line"><a name="l00519"></a><span class="lineno">  519</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00520"></a><span class="lineno">  520</span>&#160;<span class="preprocessor"></span>    <span class="keywordtype">bool</span> ret = <span class="keyword">false</span>;</div>
<div class="line"><a name="l00521"></a><span class="lineno">  521</span>&#160;    <span class="keywordflow">if</span> (mysql_commit(db-&gt;mysql) == 0) {</div>
<div class="line"><a name="l00522"></a><span class="lineno">  522</span>&#160;        ret = <span class="keyword">true</span>;</div>
<div class="line"><a name="l00523"></a><span class="lineno">  523</span>&#160;    }</div>
<div class="line"><a name="l00524"></a><span class="lineno">  524</span>&#160;</div>
<div class="line"><a name="l00525"></a><span class="lineno">  525</span>&#160;    <span class="keywordflow">if</span> (db-&gt;qmutex.count &gt; 0) {</div>
<div class="line"><a name="l00526"></a><span class="lineno">  526</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00527"></a><span class="lineno">  527</span>&#160;    }</div>
<div class="line"><a name="l00528"></a><span class="lineno">  528</span>&#160;    <span class="keywordflow">return</span> ret;</div>
<div class="line"><a name="l00529"></a><span class="lineno">  529</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00530"></a><span class="lineno">  530</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00531"></a><span class="lineno">  531</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00532"></a><span class="lineno">  532</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00533"></a><span class="lineno">  533</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00534"></a><span class="lineno">  534</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00535"></a><span class="lineno">  535</span>&#160;<span class="comment"> * qdb-&gt;rellback(): Roll-back and abort transaction</span></div>
<div class="line"><a name="l00536"></a><span class="lineno">  536</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00537"></a><span class="lineno">  537</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00538"></a><span class="lineno">  538</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00539"></a><span class="lineno">  539</span>&#160;<span class="comment"> * @return true if successful, otherwise returns false</span></div>
<div class="line"><a name="l00540"></a><span class="lineno">  540</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00541"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a6ee4a69fbc4ecf80e795d6b6b3750ca7">  541</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a6ee4a69fbc4ecf80e795d6b6b3750ca7">rollback</a>(qdb_t *db)</div>
<div class="line"><a name="l00542"></a><span class="lineno">  542</span>&#160;{</div>
<div class="line"><a name="l00543"></a><span class="lineno">  543</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00544"></a><span class="lineno">  544</span>&#160;</div>
<div class="line"><a name="l00545"></a><span class="lineno">  545</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00546"></a><span class="lineno">  546</span>&#160;<span class="preprocessor"></span>    <span class="keywordtype">bool</span> ret = <span class="keyword">false</span>;</div>
<div class="line"><a name="l00547"></a><span class="lineno">  547</span>&#160;    <span class="keywordflow">if</span> (mysql_rollback(db-&gt;mysql) == 0) {</div>
<div class="line"><a name="l00548"></a><span class="lineno">  548</span>&#160;        ret = <span class="keyword">true</span>;</div>
<div class="line"><a name="l00549"></a><span class="lineno">  549</span>&#160;    }</div>
<div class="line"><a name="l00550"></a><span class="lineno">  550</span>&#160;</div>
<div class="line"><a name="l00551"></a><span class="lineno">  551</span>&#160;    <span class="keywordflow">if</span> (db-&gt;qmutex.count &gt; 0) {</div>
<div class="line"><a name="l00552"></a><span class="lineno">  552</span>&#160;        Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00553"></a><span class="lineno">  553</span>&#160;    }</div>
<div class="line"><a name="l00554"></a><span class="lineno">  554</span>&#160;    <span class="keywordflow">return</span> ret;</div>
<div class="line"><a name="l00555"></a><span class="lineno">  555</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00556"></a><span class="lineno">  556</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00557"></a><span class="lineno">  557</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00558"></a><span class="lineno">  558</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00559"></a><span class="lineno">  559</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00560"></a><span class="lineno">  560</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00561"></a><span class="lineno">  561</span>&#160;<span class="comment"> * qdb-&gt;set_fetchtype(): Set result fetching type</span></div>
<div class="line"><a name="l00562"></a><span class="lineno">  562</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00563"></a><span class="lineno">  563</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00564"></a><span class="lineno">  564</span>&#160;<span class="comment"> * @param fromdb    false for storing the results to client (default mode),</span></div>
<div class="line"><a name="l00565"></a><span class="lineno">  565</span>&#160;<span class="comment"> *                  true for fetching directly from server,</span></div>
<div class="line"><a name="l00566"></a><span class="lineno">  566</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00567"></a><span class="lineno">  567</span>&#160;<span class="comment"> * @return true if successful otherwise returns false</span></div>
<div class="line"><a name="l00568"></a><span class="lineno">  568</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00569"></a><span class="lineno">  569</span>&#160;<span class="comment"> * @note</span></div>
<div class="line"><a name="l00570"></a><span class="lineno">  570</span>&#160;<span class="comment"> *  If qdb-&gt;set_fetchtype(db, true) is called, the results does not</span></div>
<div class="line"><a name="l00571"></a><span class="lineno">  571</span>&#160;<span class="comment"> *  actually read into the client. Instead, each row must be retrieved</span></div>
<div class="line"><a name="l00572"></a><span class="lineno">  572</span>&#160;<span class="comment"> *  individually by making calls to qdbresult-&gt;get_next().</span></div>
<div class="line"><a name="l00573"></a><span class="lineno">  573</span>&#160;<span class="comment"> *  This reads the result of a query directly from the server without storing</span></div>
<div class="line"><a name="l00574"></a><span class="lineno">  574</span>&#160;<span class="comment"> *  it in local buffer, which is somewhat faster and uses much less memory than</span></div>
<div class="line"><a name="l00575"></a><span class="lineno">  575</span>&#160;<span class="comment"> *  default behavior qdb-&gt;set_fetchtype(db, false).</span></div>
<div class="line"><a name="l00576"></a><span class="lineno">  576</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00577"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a5dc988c35746fe8a792702523abc66b3">  577</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a5dc988c35746fe8a792702523abc66b3">set_fetchtype</a>(qdb_t *db, <span class="keywordtype">bool</span> fromdb)</div>
<div class="line"><a name="l00578"></a><span class="lineno">  578</span>&#160;{</div>
<div class="line"><a name="l00579"></a><span class="lineno">  579</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00580"></a><span class="lineno">  580</span>&#160;    db-&gt;info.fetchtype = fromdb;</div>
<div class="line"><a name="l00581"></a><span class="lineno">  581</span>&#160;    <span class="keywordflow">return</span> <span class="keyword">true</span>;</div>
<div class="line"><a name="l00582"></a><span class="lineno">  582</span>&#160;}</div>
<div class="line"><a name="l00583"></a><span class="lineno">  583</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00584"></a><span class="lineno">  584</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00585"></a><span class="lineno">  585</span>&#160;<span class="comment"> * qdb-&gt;get_conn_status(): Get last connection status</span></div>
<div class="line"><a name="l00586"></a><span class="lineno">  586</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00587"></a><span class="lineno">  587</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00588"></a><span class="lineno">  588</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00589"></a><span class="lineno">  589</span>&#160;<span class="comment"> * @return true if the connection flag is set to alive, otherwise returns false</span></div>
<div class="line"><a name="l00590"></a><span class="lineno">  590</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00591"></a><span class="lineno">  591</span>&#160;<span class="comment"> * @note</span></div>
<div class="line"><a name="l00592"></a><span class="lineno">  592</span>&#160;<span class="comment"> * This function just returns the the connection status flag.</span></div>
<div class="line"><a name="l00593"></a><span class="lineno">  593</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00594"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a0598e067ed6b749c9df042cd7bc83f5c">  594</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a0598e067ed6b749c9df042cd7bc83f5c">get_conn_status</a>(qdb_t *db)</div>
<div class="line"><a name="l00595"></a><span class="lineno">  595</span>&#160;{</div>
<div class="line"><a name="l00596"></a><span class="lineno">  596</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00597"></a><span class="lineno">  597</span>&#160;</div>
<div class="line"><a name="l00598"></a><span class="lineno">  598</span>&#160;    <span class="keywordflow">return</span> db-&gt;connected;</div>
<div class="line"><a name="l00599"></a><span class="lineno">  599</span>&#160;}</div>
<div class="line"><a name="l00600"></a><span class="lineno">  600</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00601"></a><span class="lineno">  601</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00602"></a><span class="lineno">  602</span>&#160;<span class="comment"> * qdb-&gt;ping(): Checks whether the connection to the server is working.</span></div>
<div class="line"><a name="l00603"></a><span class="lineno">  603</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00604"></a><span class="lineno">  604</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00605"></a><span class="lineno">  605</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00606"></a><span class="lineno">  606</span>&#160;<span class="comment"> * @return true if connection is alive, false if connection is not available</span></div>
<div class="line"><a name="l00607"></a><span class="lineno">  607</span>&#160;<span class="comment"> *         and failed to reconnect</span></div>
<div class="line"><a name="l00608"></a><span class="lineno">  608</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00609"></a><span class="lineno">  609</span>&#160;<span class="comment"> * @note</span></div>
<div class="line"><a name="l00610"></a><span class="lineno">  610</span>&#160;<span class="comment"> * If the connection has gone down, an attempt to reconnect.</span></div>
<div class="line"><a name="l00611"></a><span class="lineno">  611</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00612"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a998f1143e4b00ff847f120e34a0efc0d">  612</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#a998f1143e4b00ff847f120e34a0efc0d">ping</a>(qdb_t *db)</div>
<div class="line"><a name="l00613"></a><span class="lineno">  613</span>&#160;{</div>
<div class="line"><a name="l00614"></a><span class="lineno">  614</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00615"></a><span class="lineno">  615</span>&#160;</div>
<div class="line"><a name="l00616"></a><span class="lineno">  616</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00617"></a><span class="lineno">  617</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (db-&gt;connected == <span class="keyword">true</span> &amp;&amp; mysql_ping(db-&gt;mysql) == 0) {</div>
<div class="line"><a name="l00618"></a><span class="lineno">  618</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">true</span>;</div>
<div class="line"><a name="l00619"></a><span class="lineno">  619</span>&#160;    } <span class="keywordflow">else</span> {  <span class="comment">// ping test failed</span></div>
<div class="line"><a name="l00620"></a><span class="lineno">  620</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="qdatabase_8c.html#ae90a2206952d27df4a58995628741134">open_</a>(db) == <span class="keyword">true</span>) {  <span class="comment">// try re-connect</span></div>
<div class="line"><a name="l00621"></a><span class="lineno">  621</span>&#160;            DEBUG(<span class="stringliteral">&quot;Connection recovered.&quot;</span>);</div>
<div class="line"><a name="l00622"></a><span class="lineno">  622</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">true</span>;</div>
<div class="line"><a name="l00623"></a><span class="lineno">  623</span>&#160;        }</div>
<div class="line"><a name="l00624"></a><span class="lineno">  624</span>&#160;    }</div>
<div class="line"><a name="l00625"></a><span class="lineno">  625</span>&#160;</div>
<div class="line"><a name="l00626"></a><span class="lineno">  626</span>&#160;    <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00627"></a><span class="lineno">  627</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00628"></a><span class="lineno">  628</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00629"></a><span class="lineno">  629</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00630"></a><span class="lineno">  630</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00631"></a><span class="lineno">  631</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00632"></a><span class="lineno">  632</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00633"></a><span class="lineno">  633</span>&#160;<span class="comment"> * qdb-&gt;get_error(): Get error number and message</span></div>
<div class="line"><a name="l00634"></a><span class="lineno">  634</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00635"></a><span class="lineno">  635</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00636"></a><span class="lineno">  636</span>&#160;<span class="comment"> * @param errorno   if not NULL, error number will be stored</span></div>
<div class="line"><a name="l00637"></a><span class="lineno">  637</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00638"></a><span class="lineno">  638</span>&#160;<span class="comment"> * @return a pointer of error message string</span></div>
<div class="line"><a name="l00639"></a><span class="lineno">  639</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00640"></a><span class="lineno">  640</span>&#160;<span class="comment"> * @note</span></div>
<div class="line"><a name="l00641"></a><span class="lineno">  641</span>&#160;<span class="comment"> * Do not free returned error message</span></div>
<div class="line"><a name="l00642"></a><span class="lineno">  642</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00643"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a11f5b1c5de493c27e1d396f7593408a0">  643</a></span>&#160;<span class="keyword">static</span> <span class="keyword">const</span> <span class="keywordtype">char</span> *<a class="code" href="qdatabase_8c.html#a11f5b1c5de493c27e1d396f7593408a0">get_error</a>(qdb_t *db, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> *errorno)</div>
<div class="line"><a name="l00644"></a><span class="lineno">  644</span>&#160;{</div>
<div class="line"><a name="l00645"></a><span class="lineno">  645</span>&#160;    <span class="keywordflow">if</span> (db == NULL || db-&gt;connected == <span class="keyword">false</span>) <span class="keywordflow">return</span> <span class="stringliteral">&quot;(no opened db)&quot;</span>;</div>
<div class="line"><a name="l00646"></a><span class="lineno">  646</span>&#160;</div>
<div class="line"><a name="l00647"></a><span class="lineno">  647</span>&#160;    <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> eno = 0;</div>
<div class="line"><a name="l00648"></a><span class="lineno">  648</span>&#160;    <span class="keyword">const</span> <span class="keywordtype">char</span> *emsg;</div>
<div class="line"><a name="l00649"></a><span class="lineno">  649</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00650"></a><span class="lineno">  650</span>&#160;<span class="preprocessor"></span>    eno = mysql_errno(db-&gt;mysql);</div>
<div class="line"><a name="l00651"></a><span class="lineno">  651</span>&#160;    <span class="keywordflow">if</span> (eno == 0) emsg = <span class="stringliteral">&quot;(no error)&quot;</span>;</div>
<div class="line"><a name="l00652"></a><span class="lineno">  652</span>&#160;    <span class="keywordflow">else</span> emsg = mysql_error(db-&gt;mysql);</div>
<div class="line"><a name="l00653"></a><span class="lineno">  653</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00654"></a><span class="lineno">  654</span>&#160;<span class="preprocessor"></span>    emsg = <span class="stringliteral">&quot;(not implemented)&quot;</span>;</div>
<div class="line"><a name="l00655"></a><span class="lineno">  655</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00656"></a><span class="lineno">  656</span>&#160;<span class="preprocessor"></span></div>
<div class="line"><a name="l00657"></a><span class="lineno">  657</span>&#160;    <span class="keywordflow">if</span> (errorno != NULL) *errorno = eno;</div>
<div class="line"><a name="l00658"></a><span class="lineno">  658</span>&#160;    <span class="keywordflow">return</span> emsg;</div>
<div class="line"><a name="l00659"></a><span class="lineno">  659</span>&#160;}</div>
<div class="line"><a name="l00660"></a><span class="lineno">  660</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00661"></a><span class="lineno">  661</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00662"></a><span class="lineno">  662</span>&#160;<span class="comment"> * qdb-&gt;free(): De-allocate qdb_t structure</span></div>
<div class="line"><a name="l00663"></a><span class="lineno">  663</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00664"></a><span class="lineno">  664</span>&#160;<span class="comment"> * @param db        a pointer of qdb_t object</span></div>
<div class="line"><a name="l00665"></a><span class="lineno">  665</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00666"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#afe5578f18ea12e68e96a80b91bd9be9d">  666</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="qdatabase_8c.html#afe5578f18ea12e68e96a80b91bd9be9d">free_</a>(qdb_t *db)</div>
<div class="line"><a name="l00667"></a><span class="lineno">  667</span>&#160;{</div>
<div class="line"><a name="l00668"></a><span class="lineno">  668</span>&#160;    <span class="keywordflow">if</span> (db == NULL) <span class="keywordflow">return</span>;</div>
<div class="line"><a name="l00669"></a><span class="lineno">  669</span>&#160;</div>
<div class="line"><a name="l00670"></a><span class="lineno">  670</span>&#160;    Q_MUTEX_ENTER(db-&gt;qmutex);</div>
<div class="line"><a name="l00671"></a><span class="lineno">  671</span>&#160;</div>
<div class="line"><a name="l00672"></a><span class="lineno">  672</span>&#160;    <a class="code" href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a>(db);</div>
<div class="line"><a name="l00673"></a><span class="lineno">  673</span>&#160;</div>
<div class="line"><a name="l00674"></a><span class="lineno">  674</span>&#160;    free(db-&gt;info.dbtype);</div>
<div class="line"><a name="l00675"></a><span class="lineno">  675</span>&#160;    free(db-&gt;info.addr);</div>
<div class="line"><a name="l00676"></a><span class="lineno">  676</span>&#160;    free(db-&gt;info.username);</div>
<div class="line"><a name="l00677"></a><span class="lineno">  677</span>&#160;    free(db-&gt;info.password);</div>
<div class="line"><a name="l00678"></a><span class="lineno">  678</span>&#160;    free(db-&gt;info.database);</div>
<div class="line"><a name="l00679"></a><span class="lineno">  679</span>&#160;    free(db);</div>
<div class="line"><a name="l00680"></a><span class="lineno">  680</span>&#160;</div>
<div class="line"><a name="l00681"></a><span class="lineno">  681</span>&#160;    Q_MUTEX_LEAVE(db-&gt;qmutex);</div>
<div class="line"><a name="l00682"></a><span class="lineno">  682</span>&#160;    Q_MUTEX_DESTROY(db-&gt;qmutex);</div>
<div class="line"><a name="l00683"></a><span class="lineno">  683</span>&#160;</div>
<div class="line"><a name="l00684"></a><span class="lineno">  684</span>&#160;    <span class="keywordflow">return</span>;</div>
<div class="line"><a name="l00685"></a><span class="lineno">  685</span>&#160;}</div>
<div class="line"><a name="l00686"></a><span class="lineno">  686</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00687"></a><span class="lineno">  687</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00688"></a><span class="lineno">  688</span>&#160;<span class="comment"> * qdbresult-&gt;get_str(): Get the result as string by field name</span></div>
<div class="line"><a name="l00689"></a><span class="lineno">  689</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00690"></a><span class="lineno">  690</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00691"></a><span class="lineno">  691</span>&#160;<span class="comment"> * @param field     column name</span></div>
<div class="line"><a name="l00692"></a><span class="lineno">  692</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00693"></a><span class="lineno">  693</span>&#160;<span class="comment"> * @return a string pointer if successful, otherwise returns NULL.</span></div>
<div class="line"><a name="l00694"></a><span class="lineno">  694</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00695"></a><span class="lineno">  695</span>&#160;<span class="comment"> * @note</span></div>
<div class="line"><a name="l00696"></a><span class="lineno">  696</span>&#160;<span class="comment"> * Do not free returned string.</span></div>
<div class="line"><a name="l00697"></a><span class="lineno">  697</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00698"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a3c32ab62afb92fb6a55cfaff7c92bf42">  698</a></span>&#160;<span class="keyword">static</span> <span class="keyword">const</span> <span class="keywordtype">char</span> *<a class="code" href="qdatabase_8c.html#a3c32ab62afb92fb6a55cfaff7c92bf42">_resultGetStr</a>(qdbresult_t *result, <span class="keyword">const</span> <span class="keywordtype">char</span> *field)</div>
<div class="line"><a name="l00699"></a><span class="lineno">  699</span>&#160;{</div>
<div class="line"><a name="l00700"></a><span class="lineno">  700</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00701"></a><span class="lineno">  701</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (result == NULL || result-&gt;rs == NULL || result-&gt;cols &lt;= 0) <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00702"></a><span class="lineno">  702</span>&#160;</div>
<div class="line"><a name="l00703"></a><span class="lineno">  703</span>&#160;    <span class="keywordflow">if</span> (result-&gt;fields == NULL) result-&gt;fields = mysql_fetch_fields(result-&gt;rs);</div>
<div class="line"><a name="l00704"></a><span class="lineno">  704</span>&#160;</div>
<div class="line"><a name="l00705"></a><span class="lineno">  705</span>&#160;    <span class="keywordtype">int</span> i;</div>
<div class="line"><a name="l00706"></a><span class="lineno">  706</span>&#160;    <span class="keywordflow">for</span> (i = 0; i &lt; result-&gt;cols; i++) {</div>
<div class="line"><a name="l00707"></a><span class="lineno">  707</span>&#160;        <span class="keywordflow">if</span> (!strcasecmp(result-&gt;fields[i].name, field)) {</div>
<div class="line"><a name="l00708"></a><span class="lineno">  708</span>&#160;            <span class="keywordflow">return</span> result-&gt;get_str_at(result, i + 1);</div>
<div class="line"><a name="l00709"></a><span class="lineno">  709</span>&#160;        }</div>
<div class="line"><a name="l00710"></a><span class="lineno">  710</span>&#160;    }</div>
<div class="line"><a name="l00711"></a><span class="lineno">  711</span>&#160;</div>
<div class="line"><a name="l00712"></a><span class="lineno">  712</span>&#160;    <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00713"></a><span class="lineno">  713</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00714"></a><span class="lineno">  714</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00715"></a><span class="lineno">  715</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00716"></a><span class="lineno">  716</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00717"></a><span class="lineno">  717</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00718"></a><span class="lineno">  718</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00719"></a><span class="lineno">  719</span>&#160;<span class="comment"> * qdbresult-&gt;get_str_at(): Get the result as string by column number</span></div>
<div class="line"><a name="l00720"></a><span class="lineno">  720</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00721"></a><span class="lineno">  721</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00722"></a><span class="lineno">  722</span>&#160;<span class="comment"> * @param idx       column number (first column is 1)</span></div>
<div class="line"><a name="l00723"></a><span class="lineno">  723</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00724"></a><span class="lineno">  724</span>&#160;<span class="comment"> * @return a string pointer if successful, otherwise returns NULL.</span></div>
<div class="line"><a name="l00725"></a><span class="lineno">  725</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00726"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#ae3559441aaa0ae5f19965612dccca8d5">  726</a></span>&#160;<span class="keyword">static</span> <span class="keyword">const</span> <span class="keywordtype">char</span> *<a class="code" href="qdatabase_8c.html#ae3559441aaa0ae5f19965612dccca8d5">_resultGetStrAt</a>(qdbresult_t *result, <span class="keywordtype">int</span> idx)</div>
<div class="line"><a name="l00727"></a><span class="lineno">  727</span>&#160;{</div>
<div class="line"><a name="l00728"></a><span class="lineno">  728</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00729"></a><span class="lineno">  729</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (result == NULL</div>
<div class="line"><a name="l00730"></a><span class="lineno">  730</span>&#160;            || result-&gt;rs == NULL</div>
<div class="line"><a name="l00731"></a><span class="lineno">  731</span>&#160;            || result-&gt;cursor == 0</div>
<div class="line"><a name="l00732"></a><span class="lineno">  732</span>&#160;            || idx &lt;= 0</div>
<div class="line"><a name="l00733"></a><span class="lineno">  733</span>&#160;            || idx &gt; result-&gt;cols ) {</div>
<div class="line"><a name="l00734"></a><span class="lineno">  734</span>&#160;        <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00735"></a><span class="lineno">  735</span>&#160;    }</div>
<div class="line"><a name="l00736"></a><span class="lineno">  736</span>&#160;    <span class="keywordflow">return</span> result-&gt;row[idx-1];</div>
<div class="line"><a name="l00737"></a><span class="lineno">  737</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00738"></a><span class="lineno">  738</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> NULL;</div>
<div class="line"><a name="l00739"></a><span class="lineno">  739</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00740"></a><span class="lineno">  740</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00741"></a><span class="lineno">  741</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00742"></a><span class="lineno">  742</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00743"></a><span class="lineno">  743</span>&#160;<span class="comment"> * qdbresult-&gt;get_int(): Get the result as integer by field name</span></div>
<div class="line"><a name="l00744"></a><span class="lineno">  744</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00745"></a><span class="lineno">  745</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00746"></a><span class="lineno">  746</span>&#160;<span class="comment"> * @param field     column name</span></div>
<div class="line"><a name="l00747"></a><span class="lineno">  747</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00748"></a><span class="lineno">  748</span>&#160;<span class="comment"> * @return a integer converted value</span></div>
<div class="line"><a name="l00749"></a><span class="lineno">  749</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00750"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#aa7608c9e6913b4d3c71d62cd43073fd1">  750</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#aa7608c9e6913b4d3c71d62cd43073fd1">_resultGetInt</a>(qdbresult_t *result, <span class="keyword">const</span> <span class="keywordtype">char</span> *field)</div>
<div class="line"><a name="l00751"></a><span class="lineno">  751</span>&#160;{</div>
<div class="line"><a name="l00752"></a><span class="lineno">  752</span>&#160;    <span class="keyword">const</span> <span class="keywordtype">char</span> *val = result-&gt;get_str(result, field);</div>
<div class="line"><a name="l00753"></a><span class="lineno">  753</span>&#160;    <span class="keywordflow">if</span> (val == NULL) <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00754"></a><span class="lineno">  754</span>&#160;    <span class="keywordflow">return</span> atoi(val);</div>
<div class="line"><a name="l00755"></a><span class="lineno">  755</span>&#160;}</div>
<div class="line"><a name="l00756"></a><span class="lineno">  756</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00757"></a><span class="lineno">  757</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00758"></a><span class="lineno">  758</span>&#160;<span class="comment"> * qdbresult-&gt;get_int_at(): Get the result as integer by column number</span></div>
<div class="line"><a name="l00759"></a><span class="lineno">  759</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00760"></a><span class="lineno">  760</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00761"></a><span class="lineno">  761</span>&#160;<span class="comment"> * @param idx       column number (first column is 1)</span></div>
<div class="line"><a name="l00762"></a><span class="lineno">  762</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00763"></a><span class="lineno">  763</span>&#160;<span class="comment"> * @return a integer converted value</span></div>
<div class="line"><a name="l00764"></a><span class="lineno">  764</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00765"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a6b5beda54ba78647276bc180f65138ca">  765</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a6b5beda54ba78647276bc180f65138ca">_resultGetIntAt</a>(qdbresult_t *result, <span class="keywordtype">int</span> idx)</div>
<div class="line"><a name="l00766"></a><span class="lineno">  766</span>&#160;{</div>
<div class="line"><a name="l00767"></a><span class="lineno">  767</span>&#160;    <span class="keyword">const</span> <span class="keywordtype">char</span> *val = result-&gt;get_str_at(result, idx);</div>
<div class="line"><a name="l00768"></a><span class="lineno">  768</span>&#160;    <span class="keywordflow">if</span> (val == NULL) <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00769"></a><span class="lineno">  769</span>&#160;    <span class="keywordflow">return</span> atoi(val);</div>
<div class="line"><a name="l00770"></a><span class="lineno">  770</span>&#160;}</div>
<div class="line"><a name="l00771"></a><span class="lineno">  771</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00772"></a><span class="lineno">  772</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00773"></a><span class="lineno">  773</span>&#160;<span class="comment"> * qdbresult-&gt;get_next(): Retrieves the next row of a result set</span></div>
<div class="line"><a name="l00774"></a><span class="lineno">  774</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00775"></a><span class="lineno">  775</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00776"></a><span class="lineno">  776</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00777"></a><span class="lineno">  777</span>&#160;<span class="comment"> * @return true if successful, false if no more rows are left</span></div>
<div class="line"><a name="l00778"></a><span class="lineno">  778</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00779"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#aeb86d8858bb8ea5dd06e052f8f3e9a09">  779</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">bool</span> <a class="code" href="qdatabase_8c.html#aeb86d8858bb8ea5dd06e052f8f3e9a09">_resultGetNext</a>(qdbresult_t *result)</div>
<div class="line"><a name="l00780"></a><span class="lineno">  780</span>&#160;{</div>
<div class="line"><a name="l00781"></a><span class="lineno">  781</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00782"></a><span class="lineno">  782</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (result == NULL || result-&gt;rs == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00783"></a><span class="lineno">  783</span>&#160;</div>
<div class="line"><a name="l00784"></a><span class="lineno">  784</span>&#160;    <span class="keywordflow">if</span> ((result-&gt;row = mysql_fetch_row(result-&gt;rs)) == NULL) <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00785"></a><span class="lineno">  785</span>&#160;    result-&gt;cursor++;</div>
<div class="line"><a name="l00786"></a><span class="lineno">  786</span>&#160;</div>
<div class="line"><a name="l00787"></a><span class="lineno">  787</span>&#160;    <span class="keywordflow">return</span> <span class="keyword">true</span>;</div>
<div class="line"><a name="l00788"></a><span class="lineno">  788</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00789"></a><span class="lineno">  789</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> <span class="keyword">false</span>;</div>
<div class="line"><a name="l00790"></a><span class="lineno">  790</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00791"></a><span class="lineno">  791</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00792"></a><span class="lineno">  792</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00793"></a><span class="lineno">  793</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00794"></a><span class="lineno">  794</span>&#160;<span class="comment"> * qdbresult-&gt;get_cols(): Get the number of columns in the result set</span></div>
<div class="line"><a name="l00795"></a><span class="lineno">  795</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00796"></a><span class="lineno">  796</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00797"></a><span class="lineno">  797</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00798"></a><span class="lineno">  798</span>&#160;<span class="comment"> * @return the number of columns in the result set</span></div>
<div class="line"><a name="l00799"></a><span class="lineno">  799</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00800"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a95d88451db51492ae6122701ce56b94d">  800</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a95d88451db51492ae6122701ce56b94d">result_get_cols</a>(qdbresult_t *result)</div>
<div class="line"><a name="l00801"></a><span class="lineno">  801</span>&#160;{</div>
<div class="line"><a name="l00802"></a><span class="lineno">  802</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00803"></a><span class="lineno">  803</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (result == NULL || result-&gt;rs == NULL) <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00804"></a><span class="lineno">  804</span>&#160;    <span class="keywordflow">return</span> result-&gt;cols;</div>
<div class="line"><a name="l00805"></a><span class="lineno">  805</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00806"></a><span class="lineno">  806</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00807"></a><span class="lineno">  807</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00808"></a><span class="lineno">  808</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00809"></a><span class="lineno">  809</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00810"></a><span class="lineno">  810</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00811"></a><span class="lineno">  811</span>&#160;<span class="comment"> * qdbresult-&gt;get_rows(): Get the number of rows in the result set</span></div>
<div class="line"><a name="l00812"></a><span class="lineno">  812</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00813"></a><span class="lineno">  813</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00814"></a><span class="lineno">  814</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00815"></a><span class="lineno">  815</span>&#160;<span class="comment"> * @return the number of rows in the result set</span></div>
<div class="line"><a name="l00816"></a><span class="lineno">  816</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00817"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a26f8b55348c57f467d64c002ab306ff6">  817</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a26f8b55348c57f467d64c002ab306ff6">result_get_rows</a>(qdbresult_t *result)</div>
<div class="line"><a name="l00818"></a><span class="lineno">  818</span>&#160;{</div>
<div class="line"><a name="l00819"></a><span class="lineno">  819</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00820"></a><span class="lineno">  820</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (result == NULL || result-&gt;rs == NULL) <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00821"></a><span class="lineno">  821</span>&#160;    <span class="keywordflow">return</span> mysql_num_rows(result-&gt;rs);</div>
<div class="line"><a name="l00822"></a><span class="lineno">  822</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00823"></a><span class="lineno">  823</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00824"></a><span class="lineno">  824</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00825"></a><span class="lineno">  825</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00826"></a><span class="lineno">  826</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00827"></a><span class="lineno">  827</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00828"></a><span class="lineno">  828</span>&#160;<span class="comment"> * qdbresult-&gt;get_row(): Get the current row number</span></div>
<div class="line"><a name="l00829"></a><span class="lineno">  829</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00830"></a><span class="lineno">  830</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00831"></a><span class="lineno">  831</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00832"></a><span class="lineno">  832</span>&#160;<span class="comment"> * @return current fetching row number of the result set</span></div>
<div class="line"><a name="l00833"></a><span class="lineno">  833</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00834"></a><span class="lineno">  834</span>&#160;<span class="comment"> * @note</span></div>
<div class="line"><a name="l00835"></a><span class="lineno">  835</span>&#160;<span class="comment"> * This number is sequencial counter which is started from 1.</span></div>
<div class="line"><a name="l00836"></a><span class="lineno">  836</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00837"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a396a7328f7fb499f89c2652598185dc8">  837</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="qdatabase_8c.html#a396a7328f7fb499f89c2652598185dc8">result_get_row</a>(qdbresult_t *result)</div>
<div class="line"><a name="l00838"></a><span class="lineno">  838</span>&#160;{</div>
<div class="line"><a name="l00839"></a><span class="lineno">  839</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00840"></a><span class="lineno">  840</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (result == NULL || result-&gt;rs == NULL) <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00841"></a><span class="lineno">  841</span>&#160;    <span class="keywordflow">return</span> result-&gt;cursor;</div>
<div class="line"><a name="l00842"></a><span class="lineno">  842</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00843"></a><span class="lineno">  843</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span> 0;</div>
<div class="line"><a name="l00844"></a><span class="lineno">  844</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00845"></a><span class="lineno">  845</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00846"></a><span class="lineno">  846</span>&#160;<span class="comment"></span></div>
<div class="line"><a name="l00847"></a><span class="lineno">  847</span>&#160;<span class="comment">/**</span></div>
<div class="line"><a name="l00848"></a><span class="lineno">  848</span>&#160;<span class="comment"> * qdbresult-&gt;free(): De-allocate the result</span></div>
<div class="line"><a name="l00849"></a><span class="lineno">  849</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00850"></a><span class="lineno">  850</span>&#160;<span class="comment"> * @param result    a pointer of qdbresult_t</span></div>
<div class="line"><a name="l00851"></a><span class="lineno">  851</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00852"></a><span class="lineno"><a class="line" href="qdatabase_8c.html#a4ab66a07fa82b706895e1b2c19fcd501">  852</a></span>&#160;<span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="qdatabase_8c.html#a4ab66a07fa82b706895e1b2c19fcd501">result_free</a>(qdbresult_t *result)</div>
<div class="line"><a name="l00853"></a><span class="lineno">  853</span>&#160;{</div>
<div class="line"><a name="l00854"></a><span class="lineno">  854</span>&#160;<span class="preprocessor">#ifdef Q_ENABLE_MYSQL</span></div>
<div class="line"><a name="l00855"></a><span class="lineno">  855</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">if</span> (result == NULL) <span class="keywordflow">return</span>;</div>
<div class="line"><a name="l00856"></a><span class="lineno">  856</span>&#160;    <span class="keywordflow">if</span> (result-&gt;rs != NULL) {</div>
<div class="line"><a name="l00857"></a><span class="lineno">  857</span>&#160;        <span class="keywordflow">if</span> (result-&gt;fetchtype == <span class="keyword">true</span>) {</div>
<div class="line"><a name="l00858"></a><span class="lineno">  858</span>&#160;            <span class="keywordflow">while</span> (mysql_fetch_row(result-&gt;rs) != NULL);</div>
<div class="line"><a name="l00859"></a><span class="lineno">  859</span>&#160;        }</div>
<div class="line"><a name="l00860"></a><span class="lineno">  860</span>&#160;        mysql_free_result(result-&gt;rs);</div>
<div class="line"><a name="l00861"></a><span class="lineno">  861</span>&#160;        result-&gt;rs = NULL;</div>
<div class="line"><a name="l00862"></a><span class="lineno">  862</span>&#160;    }</div>
<div class="line"><a name="l00863"></a><span class="lineno">  863</span>&#160;    free(result);</div>
<div class="line"><a name="l00864"></a><span class="lineno">  864</span>&#160;    <span class="keywordflow">return</span>;</div>
<div class="line"><a name="l00865"></a><span class="lineno">  865</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00866"></a><span class="lineno">  866</span>&#160;<span class="preprocessor"></span>    <span class="keywordflow">return</span>;</div>
<div class="line"><a name="l00867"></a><span class="lineno">  867</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00868"></a><span class="lineno">  868</span>&#160;<span class="preprocessor"></span>}</div>
<div class="line"><a name="l00869"></a><span class="lineno">  869</span>&#160;</div>
<div class="line"><a name="l00870"></a><span class="lineno">  870</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00871"></a><span class="lineno">  871</span>&#160;<span class="preprocessor"></span></div>
<div class="line"><a name="l00872"></a><span class="lineno">  872</span>&#160;<span class="preprocessor">#endif </span><span class="comment">/* DISABLE_QDATABASE */</span><span class="preprocessor"></span></div>
<div class="ttc" id="qdatabase_8c_html_aa7608c9e6913b4d3c71d62cd43073fd1"><div class="ttname"><a href="qdatabase_8c.html#aa7608c9e6913b4d3c71d62cd43073fd1">_resultGetInt</a></div><div class="ttdeci">static int _resultGetInt(qdbresult_t *result, const char *field)</div><div class="ttdoc">qdbresult-&gt;get_int(): Get the result as integer by field name </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00750">qdatabase.c:750</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a0598e067ed6b749c9df042cd7bc83f5c"><div class="ttname"><a href="qdatabase_8c.html#a0598e067ed6b749c9df042cd7bc83f5c">get_conn_status</a></div><div class="ttdeci">static bool get_conn_status(qdb_t *db)</div><div class="ttdoc">qdb-&gt;get_conn_status(): Get last connection status </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00594">qdatabase.c:594</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a5feeb5a7ad2b8531d2bdc2d5e94e344f"><div class="ttname"><a href="qdatabase_8c.html#a5feeb5a7ad2b8531d2bdc2d5e94e344f">qdb</a></div><div class="ttdeci">qdb_t * qdb(const char *dbtype, const char *addr, int port, const char *username, const char *password, const char *database, bool autocommit)</div><div class="ttdoc">Initialize internal connector structure. </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00162">qdatabase.c:162</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a42069ce53c9e45b7283e9e44a7e021d9"><div class="ttname"><a href="qdatabase_8c.html#a42069ce53c9e45b7283e9e44a7e021d9">execute_update</a></div><div class="ttdeci">static int execute_update(qdb_t *db, const char *query)</div><div class="ttdoc">qdb-&gt;execute_update(): Executes the update DML </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00352">qdatabase.c:352</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a99e372b7dd8e2d9c2bb4f762cc8dd5aa"><div class="ttname"><a href="qdatabase_8c.html#a99e372b7dd8e2d9c2bb4f762cc8dd5aa">execute_updatef</a></div><div class="ttdeci">static int execute_updatef(qdb_t *db, const char *format,...)</div><div class="ttdoc">qdb-&gt;execute_updatef(): Executes the formatted update DML </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00383">qdatabase.c:383</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a3c32ab62afb92fb6a55cfaff7c92bf42"><div class="ttname"><a href="qdatabase_8c.html#a3c32ab62afb92fb6a55cfaff7c92bf42">_resultGetStr</a></div><div class="ttdeci">static const char * _resultGetStr(qdbresult_t *result, const char *field)</div><div class="ttdoc">qdbresult-&gt;get_str(): Get the result as string by field name </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00698">qdatabase.c:698</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a396a7328f7fb499f89c2652598185dc8"><div class="ttname"><a href="qdatabase_8c.html#a396a7328f7fb499f89c2652598185dc8">result_get_row</a></div><div class="ttdeci">static int result_get_row(qdbresult_t *result)</div><div class="ttdoc">qdbresult-&gt;get_row(): Get the current row number </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00837">qdatabase.c:837</a></div></div>
<div class="ttc" id="qdatabase_8c_html_ae90a2206952d27df4a58995628741134"><div class="ttname"><a href="qdatabase_8c.html#ae90a2206952d27df4a58995628741134">open_</a></div><div class="ttdeci">static bool open_(qdb_t *db)</div><div class="ttdoc">qdb-&gt;open(): Connect to database server </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00232">qdatabase.c:232</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a6b5beda54ba78647276bc180f65138ca"><div class="ttname"><a href="qdatabase_8c.html#a6b5beda54ba78647276bc180f65138ca">_resultGetIntAt</a></div><div class="ttdeci">static int _resultGetIntAt(qdbresult_t *result, int idx)</div><div class="ttdoc">qdbresult-&gt;get_int_at(): Get the result as integer by column number </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00765">qdatabase.c:765</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a26f8b55348c57f467d64c002ab306ff6"><div class="ttname"><a href="qdatabase_8c.html#a26f8b55348c57f467d64c002ab306ff6">result_get_rows</a></div><div class="ttdeci">static int result_get_rows(qdbresult_t *result)</div><div class="ttdoc">qdbresult-&gt;get_rows(): Get the number of rows in the result set </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00817">qdatabase.c:817</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a998f1143e4b00ff847f120e34a0efc0d"><div class="ttname"><a href="qdatabase_8c.html#a998f1143e4b00ff847f120e34a0efc0d">ping</a></div><div class="ttdeci">static bool ping(qdb_t *db)</div><div class="ttdoc">qdb-&gt;ping(): Checks whether the connection to the server is working. </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00612">qdatabase.c:612</a></div></div>
<div class="ttc" id="qdatabase_8c_html_ae3559441aaa0ae5f19965612dccca8d5"><div class="ttname"><a href="qdatabase_8c.html#ae3559441aaa0ae5f19965612dccca8d5">_resultGetStrAt</a></div><div class="ttdeci">static const char * _resultGetStrAt(qdbresult_t *result, int idx)</div><div class="ttdoc">qdbresult-&gt;get_str_at(): Get the result as string by column number </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00726">qdatabase.c:726</a></div></div>
<div class="ttc" id="qdatabase_8c_html_aeb86d8858bb8ea5dd06e052f8f3e9a09"><div class="ttname"><a href="qdatabase_8c.html#aeb86d8858bb8ea5dd06e052f8f3e9a09">_resultGetNext</a></div><div class="ttdeci">static bool _resultGetNext(qdbresult_t *result)</div><div class="ttdoc">qdbresult-&gt;get_next(): Retrieves the next row of a result set </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00779">qdatabase.c:779</a></div></div>
<div class="ttc" id="qdatabase_8c_html_abe4e5330b68b3fc9ff94b086939dba82"><div class="ttname"><a href="qdatabase_8c.html#abe4e5330b68b3fc9ff94b086939dba82">execute_query</a></div><div class="ttdeci">static qdbresult_t * execute_query(qdb_t *db, const char *query)</div><div class="ttdoc">qdb-&gt;execute_query(): Executes the query </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00403">qdatabase.c:403</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a11f5b1c5de493c27e1d396f7593408a0"><div class="ttname"><a href="qdatabase_8c.html#a11f5b1c5de493c27e1d396f7593408a0">get_error</a></div><div class="ttdeci">static const char * get_error(qdb_t *db, unsigned int *errorno)</div><div class="ttdoc">qdb-&gt;get_error(): Get error number and message </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00643">qdatabase.c:643</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a4ab66a07fa82b706895e1b2c19fcd501"><div class="ttname"><a href="qdatabase_8c.html#a4ab66a07fa82b706895e1b2c19fcd501">result_free</a></div><div class="ttdeci">static void result_free(qdbresult_t *result)</div><div class="ttdoc">qdbresult-&gt;free(): De-allocate the result </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00852">qdatabase.c:852</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a95d88451db51492ae6122701ce56b94d"><div class="ttname"><a href="qdatabase_8c.html#a95d88451db51492ae6122701ce56b94d">result_get_cols</a></div><div class="ttdeci">static int result_get_cols(qdbresult_t *result)</div><div class="ttdoc">qdbresult-&gt;get_cols(): Get the number of columns in the result set </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00800">qdatabase.c:800</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a89fc888110ad23e6358d155e2c9b6a3b"><div class="ttname"><a href="qdatabase_8c.html#a89fc888110ad23e6358d155e2c9b6a3b">close_</a></div><div class="ttdeci">static bool close_(qdb_t *db)</div><div class="ttdoc">qdb-&gt;close(): Disconnect from database server </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00323">qdatabase.c:323</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a2f27adbcda036187a4714e5bcd3a247e"><div class="ttname"><a href="qdatabase_8c.html#a2f27adbcda036187a4714e5bcd3a247e">begin_tran</a></div><div class="ttdeci">static bool begin_tran(qdb_t *db)</div><div class="ttdoc">qdb-&gt;begin_tran(): Start transaction </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00484">qdatabase.c:484</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a6fde99c74f91137ac554244ac60344be"><div class="ttname"><a href="qdatabase_8c.html#a6fde99c74f91137ac554244ac60344be">execute_queryf</a></div><div class="ttdeci">static qdbresult_t * execute_queryf(qdb_t *db, const char *format,...)</div><div class="ttdoc">qdb-&gt;execute_queryf(): Executes the formatted query </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00460">qdatabase.c:460</a></div></div>
<div class="ttc" id="qdatabase_8c_html_afe5578f18ea12e68e96a80b91bd9be9d"><div class="ttname"><a href="qdatabase_8c.html#afe5578f18ea12e68e96a80b91bd9be9d">free_</a></div><div class="ttdeci">static void free_(qdb_t *db)</div><div class="ttdoc">qdb-&gt;free(): De-allocate qdb_t structure </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00666">qdatabase.c:666</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a5dc988c35746fe8a792702523abc66b3"><div class="ttname"><a href="qdatabase_8c.html#a5dc988c35746fe8a792702523abc66b3">set_fetchtype</a></div><div class="ttdeci">static bool set_fetchtype(qdb_t *db, bool fromdb)</div><div class="ttdoc">qdb-&gt;set_fetchtype(): Set result fetching type </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00577">qdatabase.c:577</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a3386b5894d03e2f48deecb0b7c0632ea"><div class="ttname"><a href="qdatabase_8c.html#a3386b5894d03e2f48deecb0b7c0632ea">commit</a></div><div class="ttdeci">static bool commit(qdb_t *db)</div><div class="ttdoc">qdb-&gt;commit(): Commit transaction </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00515">qdatabase.c:515</a></div></div>
<div class="ttc" id="qdatabase_8c_html_a6ee4a69fbc4ecf80e795d6b6b3750ca7"><div class="ttname"><a href="qdatabase_8c.html#a6ee4a69fbc4ecf80e795d6b6b3750ca7">rollback</a></div><div class="ttdeci">static bool rollback(qdb_t *db)</div><div class="ttdoc">qdb-&gt;rellback(): Roll-back and abort transaction </div><div class="ttdef"><b>Definition:</b> <a href="qdatabase_8c_source.html#l00541">qdatabase.c:541</a></div></div>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="dir_40c73bf2095fd0473b1b85ccdcac2768.html">extensions</a></li><li class="navelem"><a class="el" href="qdatabase_8c.html">qdatabase.c</a></li>
    <li class="footer">Generated by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.6 </li>
  </ul>
</div>
</body>
</html>
